nop

go to the database property and under the Options tab,

change the recovery model to 'Simple' and click on the

auto shrink check box.

for ur info, just take note the space allocated...

try using a dot .

let us know wat happens wen u use . on both the machines.

if ur not using incremental backup for ur db then i would suggest u to change the recovery model to 'simple'. and make sure the autogrow property is checked. then...

ur code looks fine

try adding ( ) 

=code.CalcPercent(Fields!lyTotals.Value , (Fields!Video.Value - Fields!lyVideo.Value))

do let us know if this works or u hv found out the solution

http://www.microsoft.com/sql/reporting/default.asp

Hi James,

Maybe when the article is out, u can let us know where can we get it

i guess the article would be a great help.....

thanks

jarret - in the Generic Query Designer u can just use the sp name without the param but make sure u change the Command Type to StoredProcedure

now if u click the...

jarretg,

my proc contains temp table and cursors...why do u say temp table wont work with RS...do u hv more info on this? any writeups?

Jack

yup....i did...

thats excatly what i did...EXEC rptDailyCumulativeProdSummaryByBussUnit '200403' 

but at the below of the 'Design the Query' dialog box an err appears when i click next = There is an...

thanks lee....

that sure did stopped me from getting tha book.

Lee and Jack,

was the book good?

Thanks